﻿CREATE PROCEDURE [dbo].[kp_HoSoXoaTruocKhiCapNhat]
	@Stt_Rec nvarchar(10)
AS
	DELETE FROM tblNganhHSo Where Stt_Rec=@Stt_Rec
	DELETE FROM tblThanhVienHSo where Stt_Rec=@Stt_Rec
	DELETE FROM tblTPHoSo WHERE Stt_Rec=@Stt_Rec
	DELETE FROM tblHoSo WHERE Stt_Rec=@Stt_Rec
RETURN 0;